package com.czy.seed.mvc.home.mapper;


import com.czy.seed.mvc.home.entity.Quotation;
import com.czy.seed.mybatis.base.QueryParams;
import com.czy.seed.mybatis.base.mapper.BaseMapper;
import com.czy.seed.mybatis.config.mybatis.annotations.AutoMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @Author: liuyun
 * Created by liuyun  11:35 2017/12/6.
 */

@AutoMapper
public interface QuotationMapper  extends BaseMapper<Quotation> {
    @Select("UPDATE Quotation set type = #{type},updatetime=sysdate(),updateuserid=#{c_userid} WHERE ID = #{id}")

    void updateQuotationById(@Param("id") Long id, @Param("type") Long type,@Param("c_userid") Long c_userid);
    @Select("UPDATE Quotation set type = #{type},updatetime=sysdate(),updateuserid=#{c_userid} WHERE QUOTE_OR_COMPARE_ID = #{id}")

    void updateQuotationOrCompaerByQuotationId(@Param("id") Long id,@Param("type") Long type,@Param("c_userid") Long c_userid);

}
